SELECT CONCAT( "" , d.document_no, "" ) As "view", CONCAT( "edit" ) As "edit", CONCAT( "" , dm.demographic_no, "" ) As "Dem#", CONCAT( "eChart" ) AS "eChart" , d.docdesc As "Doc_descripton", d.observationdate as "Date", d.doccreator as "Creator", dm.last_name "Last", dm.first_name "First", CONCAT(dm.year_of_birth,'-',dm.month_of_birth,'-',dm.date_of_birth) AS "DOB", dm.sex AS "G", dm.hin, dm.phone, CONCAT( "" ,dm.email, "" ) as "emailto", dm.phone2, dm.address, CONCAT(dm.city," ",dm.postal) as citypostal FROM demographic dm, document d, ctl_document cd WHERE dm.demographic_no = cd.module_id AND d.document_no = cd.document_no AND (d.docfilename LIKE REPLACE("%{docname}%"," ","%") OR d.docdesc LIKE REPLACE("%{docname}%"," ","%") ) Order by d.document_no desc {limitnumresult}; % 100 10 500 1000 ALL